package sv.gob.mh.dgii.dao.ed;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import org.apache.commons.beanutils.DynaBean;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;
import org.hibernate.criterion.Subqueries;
import org.hibernate.jdbc.Work;
import org.springframework.stereotype.Service;
import sv.gob.mh.dgii.common.Utils;
import sv.gob.mh.dgii.dao.hibernate.HibernateDaoImpl;
import sv.gob.mh.dgii.dao.utils.TipoProceso;

import sv.gob.mh.dgii.model.EdDeclaraciones;
import sv.gob.mh.dgii.model.TbFormularios;
import sv.gob.mh.dgii.model.TbFormulariosVersiones;
import sv.gob.mh.dgii.model.TbListasValorDet;

@Service
public class EdDeclaracionesDaoImpl extends HibernateDaoImpl implements EdDeclaracionesDao {

    Log log = LogFactory.getLog(EdDeclaracionesDaoImpl.class);
    private static final String _SEQ_NAME = "ED_DECLARACIONES";
    public static final String _C_DECLARACION = "cdeclaracion";
    public static final String _NFOLIO = "nfolio";
    // m_ingreso='B' and m_formato='D' and m_proceso='99'
    public static final String _MINGRESO = "mingreso";
    public static final String DET_MINGRESO_BANCO = "B";
    public static final String _MFORMATO = "mformato";
    public static final String DET_MFORMATO_DIG = "D";
    public static final String _MPROCESO = "mproceso";
    public static final String DET_MPROCESO_CARGA_BANCO_DIG = "99";
    public static final String _NIT = "nit";
    public static final String _F_INGRESO = "fingreso";
    public static final String _BACTIVA = "bactiva";
    public static final String _N_NOTA_ABONO = "nnotaAbono";
    public static final String _C_USU_INACTIVA = "cusuarioInactiva";
    public static final String _C_FORMULARIO = "tbFormulariosVersiones.id.cformulario";
    public static final String _C_VERSION = "tbFormulariosVersiones.id.cversion";
    public static final String _S_SIGLAS = "tbFormulariosVersiones.tbFormularios.ssiglas";
    public static final String _FP_DECLARACIONE = "fpdeclaracion";
    public static final String _F_PRESENTACION = "fpresentacion";
    public static final String _NOTA_ABONO = "edNotaAbono.nnotaAbono";
    public static final String _QUERY_DECLARACIONES = "EdDeclaraciones.getTotalsCalidad";
    public static final String _B_MODIFICATORIA = "bmodificatoria";

    public EdDeclaracionesDaoImpl() {
        super(EdDeclaraciones.class); 
	} 
}